Biorreactor 14616

Dataset statistics

Number of variables	16
Number of observations	52413
Missing cells	69744
Missing cells (%)	8.3%
Duplicate rows	1296
Duplicate rows (%)	2.5%
Total size in memory	8.8 MiB
Average record size in memory	176.3 B

Variable types

Numeric	14
Categorical	2

Alerts

Dataset has 1296 (2.5%) duplicate rows	Duplicates
`14616_FERM0101.DO_2_PV` is highly imbalanced (> 99.9%)	Imbalance
`14616_FERM0101.PUMP_1_PV` is highly imbalanced (99.9%)	Imbalance
`14616_FERM0101.Agitation_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Air_Sparge_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Biocontainer_Pressure_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.DO_1_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.DO_2_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Gas_Overlay_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Load_Cell_Net_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.pH_1_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.pH_2_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.PUMP_1_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.PUMP_1_TOTAL` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.PUMP_2_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.PUMP_2_TOTAL` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Single_Use_DO_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Single_Use_pH_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.Temperatura_PV` has 4359 (8.3%) missing values	Missing
`14616_FERM0101.pH_1_PV` is highly skewed (γ1 = -39.49908564)	Skewed
`14616_FERM0101.Agitation_PV` has 25580 (48.8%) zeros	Zeros
`14616_FERM0101.Air_Sparge_PV` has 44872 (85.6%) zeros	Zeros
`14616_FERM0101.DO_1_PV` has 37608 (71.8%) zeros	Zeros
`14616_FERM0101.Gas_Overlay_PV` has 19158 (36.6%) zeros	Zeros
`14616_FERM0101.Load_Cell_Net_PV` has 5713 (10.9%) zeros	Zeros
`14616_FERM0101.PUMP_1_TOTAL` has 5004 (9.5%) zeros	Zeros
`14616_FERM0101.PUMP_2_PV` has 42155 (80.4%) zeros	Zeros
`14616_FERM0101.PUMP_2_TOTAL` has 11511 (22.0%) zeros	Zeros

Reproduction

Analysis started	2024-09-29 18:19:53.738884
Analysis finished	2024-09-29 18:20:10.897374
Duration	17.16 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

14616_FERM0101.Agitation_PV
Real number (ℝ)

MISSING ZEROS

Distinct	730
Distinct (%)	1.5%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	27.403867

Minimum	0
Maximum	80
Zeros	25580
Zeros (%)	48.8%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	80
95-th percentile	80
Maximum	80
Range	80
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	34.856413
Coefficient of variation (CV)	1.2719524
Kurtosis	-1.29574
Mean	27.403867
Median Absolute Deviation (MAD)	0
Skewness	0.73694698
Sum	1316865.4
Variance	1214.9695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25580	48.8%
80	13771	26.3%
20	6831	13.0%
36	956	1.8%
48	96	0.2%
40	87	0.2%
44	4	< 0.1%
28	4	< 0.1%
72	3	< 0.1%
56.57600098	2	< 0.1%
Other values (720)	720	1.4%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25580	48.8%
19.37707849	1	< 0.1%
20	6831	13.0%
20.15528551	1	< 0.1%
20.1596206	1	< 0.1%
20.23029227	1	< 0.1%
20.29454404	1	< 0.1%
20.59187955	1	< 0.1%
20.61428528	1	< 0.1%
20.87142792	1	< 0.1%

Value	Count	Frequency (%)
80	13771	26.3%
79.99913088	1	< 0.1%
79.9976832	1	< 0.1%
79.94213076	1	< 0.1%
79.89445095	1	< 0.1%
79.79949191	1	< 0.1%
79.76339559	1	< 0.1%
79.71484019	1	< 0.1%
79.68511831	1	< 0.1%
79.6695619	1	< 0.1%

14616_FERM0101.Air_Sparge_PV
Real number (ℝ)

MISSING ZEROS

Distinct	3183
Distinct (%)	6.6%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	2.6985708

Minimum	0
Maximum	160.17427
Zeros	44872
Zeros (%)	85.6%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	16.384068
Maximum	160.17427
Range	160.17427
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.930932
Coefficient of variation (CV)	4.4212039
Kurtosis	22.372999
Mean	2.6985708
Median Absolute Deviation (MAD)	0
Skewness	4.6918424
Sum	129677.12
Variance	142.34713
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	44872	85.6%
39.89197036	1	< 0.1%
63.94964025	1	< 0.1%
55.84003296	1	< 0.1%
16.1447488	1	< 0.1%
59.35526123	1	< 0.1%
64.01562928	1	< 0.1%
64.33786652	1	< 0.1%
28.20182173	1	< 0.1%
40.24039019	1	< 0.1%
Other values (3173)	3173	6.1%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	44872	85.6%
0.1825548737	1	< 0.1%
0.2069595221	1	< 0.1%
0.423073211	1	< 0.1%
0.5799610216	1	< 0.1%
0.5802986694	1	< 0.1%
0.710379838	1	< 0.1%
0.8213578002	1	< 0.1%
0.8733967713	1	< 0.1%
0.9988921061	1	< 0.1%

Value	Count	Frequency (%)
160.1742683	1	< 0.1%
160.0846504	1	< 0.1%
160.0236342	1	< 0.1%
160.0210732	1	< 0.1%
160.0171183	1	< 0.1%
159.9943072	1	< 0.1%
80.09838357	1	< 0.1%
65.50563378	1	< 0.1%
65.43337873	1	< 0.1%
65.39106423	1	< 0.1%

14616_FERM0101.Biocontainer_Pressure_PV
Real number (ℝ)

MISSING

Distinct	20875
Distinct (%)	43.4%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	166.48044

Minimum	-17.678558
Maximum	480
Zeros	0
Zeros (%)	0.0%
Negative	20580
Negative (%)	39.3%
Memory size	2.8 MiB

Quantile statistics

Minimum	-17.678558
5-th percentile	-1.4333712
Q1	-0.53495697
median	0.37180388
Q3	480
95-th percentile	480
Maximum	480
Range	497.67856
Interquartile range (IQR)	480.53496

Descriptive statistics

Standard deviation	228.5384
Coefficient of variation (CV)	1.3727643
Kurtosis	-1.5866714
Mean	166.48044
Median Absolute Deviation (MAD)	1.4510844
Skewness	0.64286799
Sum	8000051.1
Variance	52229.801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
480	16673	31.8%
-0.09548339844	327	0.6%
-0.9664367676	283	0.5%
-0.298034668	260	0.5%
-0.05497436523	257	0.5%
-1.006945801	240	0.5%
-0.9461791992	239	0.5%
-0.5208312988	235	0.4%
-0.5410888672	233	0.4%
-0.7233825684	231	0.4%
Other values (20865)	29076	55.5%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-17.67855826	1	< 0.1%
-13.20023193	1	< 0.1%
-12.81082015	1	< 0.1%
-10.91346978	1	< 0.1%
-9.262522964	1	< 0.1%
-9.250579834	1	< 0.1%
-9.196256899	1	< 0.1%
-9.169561768	1	< 0.1%
-9.055902727	1	< 0.1%
-9.039486143	1	< 0.1%

Value	Count	Frequency (%)
480	16673	31.8%
363.9071863	1	< 0.1%
37.37557373	1	< 0.1%
19.14641113	1	< 0.1%
19.08400949	1	< 0.1%
18.70693948	1	< 0.1%
17.97231053	1	< 0.1%
16.6753479	1	< 0.1%
15.17650757	1	< 0.1%
14.9131958	1	< 0.1%

14616_FERM0101.DO_1_PV
Real number (ℝ)

MISSING ZEROS

Distinct	7045
Distinct (%)	14.7%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	5.0303294

Minimum	0
Maximum	113.39003
Zeros	37608
Zeros (%)	71.8%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	25.138969
Maximum	113.39003
Range	113.39003
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.980638
Coefficient of variation (CV)	2.3816806
Kurtosis	16.257979
Mean	5.0303294
Median Absolute Deviation (MAD)	0
Skewness	3.542544
Sum	241727.45
Variance	143.53568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	37608	71.8%
15.62647095	16	< 0.1%
16.31929016	12	< 0.1%
23.46226807	12	< 0.1%
15.36104279	12	< 0.1%
15.70758667	12	< 0.1%
16.25534668	12	< 0.1%
16.02679749	11	< 0.1%
17.08873749	10	< 0.1%
26.81347046	10	< 0.1%
Other values (7035)	10339	19.7%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37608	71.8%
1.618992043	1	< 0.1%
2.053528023	6	< 0.1%
2.305600929	1	< 0.1%
2.508546638	1	< 0.1%
2.516705132	1	< 0.1%
2.517918205	1	< 0.1%
2.567412758	1	< 0.1%
2.593224525	1	< 0.1%
2.611331177	4	< 0.1%

Value	Count	Frequency (%)
113.3900269	1	< 0.1%
113.2430786	1	< 0.1%
113.090686	1	< 0.1%
112.7967896	1	< 0.1%
112.7859009	1	< 0.1%
112.6389526	1	< 0.1%
112.4865601	1	< 0.1%
111.735498	1	< 0.1%
110.6850708	1	< 0.1%
110.6825277	1	< 0.1%

14616_FERM0101.DO_2_PV
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	4359
Missing (%)	8.3%
Memory size	2.8 MiB

0.0	48053
64.66350297893688	1

Length

Max length	17
Median length	3
Mean length	3.0002913
Min length	3

Characters and Unicode

Total characters	144176
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	48053	91.7%
64.66350297893688	1	< 0.1%
(Missing)	4359	8.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	48053	> 99.9%
64.66350297893688	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	96107	66.7%
.	48054	33.3%
6	4	< 0.1%
8	3	< 0.1%
3	2	< 0.1%
9	2	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
2	1	< 0.1%
7	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	144176	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	96107	66.7%
.	48054	33.3%
6	4	< 0.1%
8	3	< 0.1%
3	2	< 0.1%
9	2	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
2	1	< 0.1%
7	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	144176	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	96107	66.7%
.	48054	33.3%
6	4	< 0.1%
8	3	< 0.1%
3	2	< 0.1%
9	2	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
2	1	< 0.1%
7	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	144176	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	96107	66.7%
.	48054	33.3%
6	4	< 0.1%
8	3	< 0.1%
3	2	< 0.1%
9	2	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
2	1	< 0.1%
7	1	< 0.1%

14616_FERM0101.Gas_Overlay_PV
Real number (ℝ)

MISSING ZEROS

Distinct	28837
Distinct (%)	60.0%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	2.4375645

Minimum	0
Maximum	16.00192
Zeros	19158
Zeros (%)	36.6%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3.9997313
Q3	4.0000727
95-th percentile	4.0004599
Maximum	16.00192
Range	16.00192
Interquartile range (IQR)	4.0000727

Descriptive statistics

Standard deviation	2.0290296
Coefficient of variation (CV)	0.83240037
Kurtosis	-0.77695537
Mean	2.4375645
Median Absolute Deviation (MAD)	0.00058757444
Skewness	-0.14842114
Sum	117134.73
Variance	4.1169613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19158	36.6%
3.999837494	61	0.1%
3.99963925	1	< 0.1%
4.000073214	1	< 0.1%
4.000140437	1	< 0.1%
4.000083773	1	< 0.1%
3.999912397	1	< 0.1%
3.99978926	1	< 0.1%
4.000289883	1	< 0.1%
3.999781014	1	< 0.1%
Other values (28827)	28827	55.0%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19158	36.6%
0.9712903929	1	< 0.1%
1.599174768	1	< 0.1%
1.599450205	1	< 0.1%
1.599482904	1	< 0.1%
1.599818691	1	< 0.1%
1.59985733	1	< 0.1%
1.599864428	1	< 0.1%
1.599902071	1	< 0.1%
1.599936278	1	< 0.1%

Value	Count	Frequency (%)
16.00191957	1	< 0.1%
16.0010963	1	< 0.1%
16.00092006	1	< 0.1%
16.00070474	1	< 0.1%
16.00069152	1	< 0.1%
16.00065052	1	< 0.1%
16.00048488	1	< 0.1%
16.0004382	1	< 0.1%
15.99966755	1	< 0.1%
15.99959321	1	< 0.1%

14616_FERM0101.Load_Cell_Net_PV
Real number (ℝ)

MISSING ZEROS

Distinct	1857
Distinct (%)	3.9%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	737.50925

Minimum	-27.2
Maximum	1696.4
Zeros	5713
Zeros (%)	10.9%
Negative	16651
Negative (%)	31.8%
Memory size	2.8 MiB

Quantile statistics

Minimum	-27.2
5-th percentile	-18.4
Q1	-16.8
median	2.0330174
Q3	1584.8
95-th percentile	1665.2
Maximum	1696.4
Range	1723.6
Interquartile range (IQR)	1601.6

Descriptive statistics

Standard deviation	801.43662
Coefficient of variation (CV)	1.0866801
Kurtosis	-1.9583907
Mean	737.50925
Median Absolute Deviation (MAD)	20.433017
Skewness	0.15938066
Sum	35440270
Variance	642300.66
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-18	7638	14.6%
0	5713	10.9%
-18.4	2194	4.2%
-1.6	1265	2.4%
-17.6	1167	2.2%
-1.2	1060	2.0%
0.8	750	1.4%
0.4	724	1.4%
1576.4	534	1.0%
-2	461	0.9%
Other values (1847)	26548	50.7%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-27.2	1	< 0.1%
-25.6	4	< 0.1%
-25.2	182	0.3%
-24.8	5	< 0.1%
-24.4	2	< 0.1%
-24	1	< 0.1%
-20	4	< 0.1%
-19.2	157	0.3%
-18.8	57	0.1%
-18.4	2194	4.2%

Value	Count	Frequency (%)
1696.4	1	< 0.1%
1695.6	2	< 0.1%
1695.2	5	< 0.1%
1694.8	7	< 0.1%
1694.4	3	< 0.1%
1694	2	< 0.1%
1693.6	4	< 0.1%
1693.205024	1	< 0.1%
1693.2	5	< 0.1%
1692.8	6	< 0.1%

14616_FERM0101.pH_1_PV
Real number (ℝ)

MISSING SKEWED

Distinct	6861
Distinct (%)	14.3%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.8083132

Minimum	-16705.317
Maximum	2049.6152
Zeros	0
Zeros (%)	0.0%
Negative	28
Negative (%)	0.1%
Memory size	2.8 MiB

Quantile statistics

Minimum	-16705.317
5-th percentile	0.0060123444
Q1	1.5798328
median	1.7481483
Q3	5.8668419
95-th percentile	5.9394938
Maximum	2049.6152
Range	18754.932
Interquartile range (IQR)	4.287009

Descriptive statistics

Standard deviation	400.58657
Coefficient of variation (CV)	221.52499
Kurtosis	1643.6758
Mean	1.8083132
Median Absolute Deviation (MAD)	1.4998914
Skewness	-39.499086
Sum	86896.683
Variance	160469.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.00601234436	2500	4.8%
1.748148346	2471	4.7%
1.67491951	2081	4.0%
1.53050499	1327	2.5%
1.705440712	1238	2.4%
1.607769585	943	1.8%
1.663781166	849	1.6%
1.554140282	698	1.3%
1.679355812	650	1.2%
1.390620041	645	1.2%
Other values (6851)	34652	66.1%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-16705.31719	26	< 0.1%
-10298.18984	1	< 0.1%
-0.33400383	1	< 0.1%
0.001192850112	1	< 0.1%
0.001247440286	1	< 0.1%
0.001259128667	1	< 0.1%
0.001308620479	1	< 0.1%
0.001309268787	1	< 0.1%
0.00136826176	1	< 0.1%
0.004709544467	1	< 0.1%

Value	Count	Frequency (%)
2049.615234	1	< 0.1%
1950.344922	1	< 0.1%
1883.366797	1	< 0.1%
1687.218359	1	< 0.1%
1554.458887	1	< 0.1%
1389.407324	1	< 0.1%
1357.113574	1	< 0.1%
1355.918262	1	< 0.1%
1344.499091	1	< 0.1%
1059.302637	4	< 0.1%

14616_FERM0101.pH_2_PV
Real number (ℝ)

MISSING

Distinct	78
Distinct (%)	0.2%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	-208.91498

Minimum	-389.26096
Maximum	3.2
Zeros	38
Zeros (%)	0.1%
Negative	27342
Negative (%)	52.2%
Memory size	2.8 MiB

Quantile statistics

Minimum	-389.26096
5-th percentile	-389.26096
Q1	-389.26096
median	-389.26096
Q3	3.2
95-th percentile	3.2
Maximum	3.2
Range	392.46096
Interquartile range (IQR)	392.46096

Descriptive statistics

Standard deviation	195.4241
Coefficient of variation (CV)	-0.93542407
Kurtosis	-1.9733976
Mean	-208.91498
Median Absolute Deviation (MAD)	0
Skewness	0.16149643
Sum	-10039201
Variance	38190.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-389.2609619	25933	49.5%
3.2	20652	39.4%
-0.2329555511	1357	2.6%
0	38	0.1%
-26.87923233	1	< 0.1%
1.7517627	1	< 0.1%
1.427500248	1	< 0.1%
1.243799434	1	< 0.1%
-206.8192296	1	< 0.1%
-211.8487651	1	< 0.1%
Other values (68)	68	0.1%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-389.2609619	25933	49.5%
-389.1811626	1	< 0.1%
-387.8849362	1	< 0.1%
-385.6619304	1	< 0.1%
-385.3407178	1	< 0.1%
-379.1654863	1	< 0.1%
-377.7421594	1	< 0.1%
-336.5587212	1	< 0.1%
-333.4207645	1	< 0.1%
-314.0435053	1	< 0.1%

Value	Count	Frequency (%)
3.2	20652	39.4%
2.540166735	1	< 0.1%
2.526881296	1	< 0.1%
2.525830185	1	< 0.1%
2.520545773	1	< 0.1%
2.50901713	1	< 0.1%
2.4744223	1	< 0.1%
1.7517627	1	< 0.1%
1.739642704	1	< 0.1%
1.709809634	1	< 0.1%

14616_FERM0101.PUMP_1_PV
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	4359
Missing (%)	8.3%
Memory size	2.8 MiB

0.0	48051
48.0	3

Length

Max length	4
Median length	3
Mean length	3.0000624
Min length	3

Characters and Unicode

Total characters	144165
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	48051	91.7%
48.0	3	< 0.1%
(Missing)	4359	8.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	48051	> 99.9%
48.0	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	96105	66.7%
.	48054	33.3%
4	3	< 0.1%
8	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	144165	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	96105	66.7%
.	48054	33.3%
4	3	< 0.1%
8	3	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	144165	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	96105	66.7%
.	48054	33.3%
4	3	< 0.1%
8	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	144165	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	96105	66.7%
.	48054	33.3%
4	3	< 0.1%
8	3	< 0.1%

14616_FERM0101.PUMP_1_TOTAL
Real number (ℝ)

MISSING ZEROS

Distinct	134
Distinct (%)	0.3%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	48.465288

Minimum	0
Maximum	1321.8334
Zeros	5004
Zeros (%)	9.5%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	12.4
median	34.719998
Q3	57.03999
95-th percentile	143.84005
Maximum	1321.8334
Range	1321.8334
Interquartile range (IQR)	44.63999

Descriptive statistics

Standard deviation	60.065844
Coefficient of variation (CV)	1.239358
Kurtosis	158.68048
Mean	48.465288
Median Absolute Deviation (MAD)	22.319998
Skewness	8.4827052
Sum	2328951
Variance	3607.9056
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5004	9.5%
44.63999329	4193	8.0%
39.67999573	3251	6.2%
22.32000122	2631	5.0%
9.919999695	2574	4.9%
7.43999939	2483	4.7%
12.4	2313	4.4%
141.3600464	2035	3.9%
32.23999939	1858	3.5%
27.28000183	1818	3.5%
Other values (124)	19894	38.0%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5004	9.5%
0.8361835807	1	< 0.1%
1.317148196	1	< 0.1%
1.867436268	1	< 0.1%
2.790245837	1	< 0.1%
2.952845975	1	< 0.1%
3.534282258	1	< 0.1%
3.861208527	1	< 0.1%
4.011535205	1	< 0.1%
4.959999847	105	0.2%

Value	Count	Frequency (%)
1321.833398	37	0.1%
605.4982182	1	< 0.1%
560.4793945	41	0.1%
248.0002441	3	< 0.1%
230.64021	203	0.4%
203.3601685	180	0.3%
173.6001099	348	0.7%
171.120105	7	< 0.1%
158.7200806	648	1.2%
156.2400757	133	0.3%

14616_FERM0101.PUMP_2_PV
Real number (ℝ)

MISSING ZEROS

Distinct	5341
Distinct (%)	11.1%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.45911219

Minimum	0
Maximum	48
Zeros	42155
Zeros (%)	80.4%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4.3587261
Maximum	48
Range	48
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.5957076
Coefficient of variation (CV)	3.4756375
Kurtosis	44.681691
Mean	0.45911219
Median Absolute Deviation (MAD)	0
Skewness	4.6138661
Sum	22062.177
Variance	2.5462826
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	42155	80.4%
8	529	1.0%
0.539018631	3	< 0.1%
5.412321854	2	< 0.1%
0.7388877869	2	< 0.1%
0.01567153931	2	< 0.1%
1.186093903	2	< 0.1%
6.617565155	2	< 0.1%
2.491486931	2	< 0.1%
7.105562592	2	< 0.1%
Other values (5331)	5353	10.2%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	42155	80.4%
9.830077101 × 10^-5	1	< 0.1%
9.950694471 × 10^-5	1	< 0.1%
9.992955675 × 10^-5	1	< 0.1%
0.0001000500217	1	< 0.1%
0.0001004522341	1	< 0.1%
0.0001005209783	1	< 0.1%
0.0001074923021	1	< 0.1%
0.0001211075388	1	< 0.1%
0.0001233729154	1	< 0.1%

Value	Count	Frequency (%)
48	2	< 0.1%
8	529	1.0%
7.999999533	1	< 0.1%
7.999943062	1	< 0.1%
7.999915069	1	< 0.1%
7.99986186	1	< 0.1%
7.999731674	1	< 0.1%
7.99965581	1	< 0.1%
7.999316813	1	< 0.1%
7.999155488	1	< 0.1%

14616_FERM0101.PUMP_2_TOTAL
Real number (ℝ)

MISSING ZEROS

Distinct	7703
Distinct (%)	16.0%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	3825.4147

Minimum	0
Maximum	17888.144
Zeros	11511
Zeros (%)	22.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	150.56382
median	4049.3546
Q3	6959.1758
95-th percentile	8473.3062
Maximum	17888.144
Range	17888.144
Interquartile range (IQR)	6808.612

Descriptive statistics

Standard deviation	3443.9668
Coefficient of variation (CV)	0.90028586
Kurtosis	-0.20466211
Mean	3825.4147
Median Absolute Deviation (MAD)	3082.4559
Skewness	0.42573743
Sum	1.8382648 × 10⁸
Variance	11860907
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11511	22.0%
1321.104004	2840	5.4%
5933.626953	2695	5.1%
7054.5875	2668	5.1%
6848.110938	1619	3.1%
7503.6375	1363	2.6%
7072.089844	1337	2.6%
6674.395313	1124	2.1%
1354.402637	1075	2.1%
5896.459375	907	1.7%
Other values (7693)	20915	39.9%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11511	22.0%
1.391127586	3	< 0.1%
4.237150192	1	< 0.1%
5.280001068	1	< 0.1%
12.0999939	1	< 0.1%
16.54919434	1	< 0.1%
18.11250984	1	< 0.1%
21.36007538	1	< 0.1%
21.74338379	1	< 0.1%
22.62970123	1	< 0.1%

Value	Count	Frequency (%)
17888.14375	277	0.5%
17872.9375	1	< 0.1%
17859.80781	1	< 0.1%
17840.00625	1	< 0.1%
17803.5875	1	< 0.1%
17745.35469	1	< 0.1%
17683.875	1	< 0.1%
17630.07969	1	< 0.1%
17511.95469	1	< 0.1%
17434.75469	1	< 0.1%

14616_FERM0101.Single_Use_DO_PV
Real number (ℝ)

MISSING

Distinct	9455
Distinct (%)	19.7%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	2505.2589

Minimum	0
Maximum	32921.481
Zeros	12
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	16.229869
Q1	637.64707
median	799.99199
Q3	799.99199
95-th percentile	32921.481
Maximum	32921.481
Range	32921.481
Interquartile range (IQR)	162.34492

Descriptive statistics

Standard deviation	7622.6476
Coefficient of variation (CV)	3.0426587
Kurtosis	11.96454
Mean	2505.2589
Median Absolute Deviation (MAD)	65.042969
Skewness	3.7331117
Sum	1.2038771 × 10⁸
Variance	58104757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
799.9919922	18827	35.9%
32921.48125	2835	5.4%
734.9490234	2589	4.9%
538.4612793	2091	4.0%
675.1557129	1376	2.6%
814.0755371	1319	2.5%
816.401709	1066	2.0%
689.6482422	858	1.6%
650.4528809	755	1.4%
719.9351563	662	1.3%
Other values (9445)	15676	29.9%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12	< 0.1%
1.115547676	1	< 0.1%
1.330806984	1	< 0.1%
1.351914883	1	< 0.1%
1.470219659	1	< 0.1%
1.493391813	1	< 0.1%
1.514804086	1	< 0.1%
1.542249953	1	< 0.1%
1.545021098	1	< 0.1%
1.547876167	1	< 0.1%

Value	Count	Frequency (%)
32921.48125	2835	5.4%
26400.29596	1	< 0.1%
917.7376953	196	0.4%
916.7911133	110	0.2%
877.8580078	115	0.2%
816.401709	1066	2.0%
814.0755371	1319	2.5%
809.3755008	1	< 0.1%
808.8651886	1	< 0.1%
807.6954996	1	< 0.1%

14616_FERM0101.Single_Use_pH_PV
Real number (ℝ)

MISSING

Distinct	1699
Distinct (%)	3.5%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	616.26136

Minimum	-794.27197
Maximum	800.18398
Zeros	0
Zeros (%)	0.0%
Negative	43
Negative (%)	0.1%
Memory size	2.8 MiB

Quantile statistics

Minimum	-794.27197
5-th percentile	5.7200195
Q1	799.68799
median	799.87197
Q3	799.92798
95-th percentile	800.06401
Maximum	800.18398
Range	1594.456
Interquartile range (IQR)	0.23999023

Descriptive statistics

Standard deviation	336.03765
Coefficient of variation (CV)	0.54528431
Kurtosis	-0.22876943
Mean	616.26136
Median Absolute Deviation (MAD)	0.13603516
Skewness	-1.3004982
Sum	29613823
Variance	112921.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
799.9199707	4042	7.7%
800.0640137	3511	6.7%
799.8959961	3250	6.2%
799.6959961	3143	6.0%
799.7919922	2953	5.6%
799.8719727	2196	4.2%
5.720019531	2109	4.0%
799.6879883	1680	3.2%
799.9439941	1225	2.3%
799.8160156	1208	2.3%
Other values (1689)	22737	43.4%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-794.2719727	1	< 0.1%
-794.1359863	7	< 0.1%
-788.2399902	1	< 0.1%
-788.2353152	1	< 0.1%
-788.2351994	1	< 0.1%
-788.2319824	3	< 0.1%
-788.228793	1	< 0.1%
-788.0560059	3	< 0.1%
-788.0399902	2	< 0.1%
-788.0159668	2	< 0.1%

Value	Count	Frequency (%)
800.1839844	565	1.1%
800.1600098	448	0.9%
800.1279785	267	0.5%
800.1120117	1119	2.1%
800.0640137	3511	6.7%
800.0560059	1119	2.1%
800.0160156	374	0.7%
800.0080078	456	0.9%
800	509	1.0%
799.9919922	351	0.7%

14616_FERM0101.Temperatura_PV
Real number (ℝ)

MISSING

Distinct	31119
Distinct (%)	64.8%
Missing	4359
Missing (%)	8.3%
Infinite	0
Infinite (%)	0.0%
Mean	17.610518

Minimum	3.0159973
Maximum	80.143994
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	3.0159973
5-th percentile	3.1952619
Q1	14.070899
median	16.623999
Q3	25.231995
95-th percentile	29.623256
Maximum	80.143994
Range	77.127997
Interquartile range (IQR)	11.161096

Descriptive statistics

Standard deviation	8.5911941
Coefficient of variation (CV)	0.48784447
Kurtosis	-0.79245205
Mean	17.610518
Median Absolute Deviation (MAD)	5.9576084
Skewness	-0.10547597
Sum	846255.85
Variance	73.808615
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.60799561	1070	2.0%
29.61600342	867	1.7%
3.2	845	1.6%
29.58399658	714	1.4%
3.208001709	678	1.3%
29.56800537	459	0.9%
3.176000977	444	0.8%
29.63199463	384	0.7%
3.223999023	358	0.7%
3.167999268	266	0.5%
Other values (31109)	41969	80.1%
(Missing)	4359	8.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.015997314	1	< 0.1%
3.040002441	1	< 0.1%
3.043695288	1	< 0.1%
3.046218102	1	< 0.1%
3.047998047	3	< 0.1%
3.059195952	1	< 0.1%
3.07199707	6	< 0.1%
3.079541592	1	< 0.1%
3.080529867	1	< 0.1%
3.082664523	1	< 0.1%

Value	Count	Frequency (%)
80.14399414	1	< 0.1%
30.57431842	1	< 0.1%
30.53599854	1	< 0.1%
30.49449114	1	< 0.1%
30.42865115	1	< 0.1%
30.35999756	1	< 0.1%
30.29066676	1	< 0.1%
30.28740535	1	< 0.1%
30.26400146	1	< 0.1%
30.24799805	1	< 0.1%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	14616_FERM0101.Agitation_PV	14616_FERM0101.Air_Sparge_PV	14616_FERM0101.Biocontainer_Pressure_PV	14616_FERM0101.DO_1_PV	14616_FERM0101.DO_2_PV	14616_FERM0101.Gas_Overlay_PV	14616_FERM0101.Load_Cell_Net_PV	14616_FERM0101.pH_1_PV	14616_FERM0101.pH_2_PV	14616_FERM0101.PUMP_1_PV	14616_FERM0101.PUMP_1_TOTAL	14616_FERM0101.PUMP_2_PV	14616_FERM0101.PUMP_2_TOTAL	14616_FERM0101.Single_Use_DO_PV	14616_FERM0101.Single_Use_pH_PV	14616_FERM0101.Temperatura_PV
DateTime
2023-03-15 00:00:00.000	80.0	0.000000	0.715311	16.557993	0.0	3.999639	1652.800000	5.929625	-389.260962	0.0	39.679996	0.0	391.860913	17.361165	5.872	29.607996
2023-03-15 00:15:00.000	80.0	1.629763	0.795663	15.634378	0.0	4.000125	1652.800000	5.929625	-389.260962	0.0	39.679996	0.0	391.860913	16.468314	5.872	29.607996
2023-03-15 00:30:00.000	80.0	0.000000	0.844326	16.687202	0.0	4.000129	1652.807246	5.929625	-389.260962	0.0	39.679996	0.0	391.860913	17.516034	5.872	29.616003
2023-03-15 00:45:00.000	80.0	0.000000	0.755206	15.892802	0.0	3.999268	1652.800000	5.929625	-389.260962	0.0	39.679996	0.0	391.860913	16.595076	5.872	29.631995
2023-03-15 01:00:00.000	80.0	0.000000	0.755206	16.821199	0.0	3.999884	1652.800000	5.921457	-389.260962	0.0	39.679996	0.0	391.860913	17.754875	5.872	29.616193
2023-03-15 01:15:00.000	80.0	2.633847	0.835407	15.634284	0.0	4.000593	1652.800000	5.921457	-389.260962	0.0	39.679996	0.0	391.860913	16.447218	5.864	29.616003
2023-03-15 01:30:00.000	80.0	0.000000	0.836224	16.160793	0.0	3.999586	1652.800000	5.921457	-389.260962	0.0	39.679996	0.0	391.860913	16.890219	5.864	29.607996
2023-03-15 01:45:00.000	80.0	0.000000	0.816252	16.026797	0.0	3.999450	1652.400000	5.921457	-389.260962	0.0	39.679996	0.0	391.860913	17.375407	5.864	29.631995
2023-03-15 02:00:00.000	80.0	2.680267	0.836639	15.495602	0.0	3.999463	1652.800000	5.913288	-389.260962	0.0	39.679996	0.0	391.860913	16.349067	5.864	29.656006
2023-03-15 02:15:00.000	80.0	0.000000	0.816377	16.026797	0.0	3.999695	1652.400000	5.913288	-389.260962	0.0	39.679996	0.0	391.860913	16.728490	5.856	29.631995

	14616_FERM0101.Agitation_PV	14616_FERM0101.Air_Sparge_PV	14616_FERM0101.Biocontainer_Pressure_PV	14616_FERM0101.DO_1_PV	14616_FERM0101.DO_2_PV	14616_FERM0101.Gas_Overlay_PV	14616_FERM0101.Load_Cell_Net_PV	14616_FERM0101.pH_1_PV	14616_FERM0101.pH_2_PV	14616_FERM0101.PUMP_1_PV	14616_FERM0101.PUMP_1_TOTAL	14616_FERM0101.PUMP_2_PV	14616_FERM0101.PUMP_2_TOTAL	14616_FERM0101.Single_Use_DO_PV	14616_FERM0101.Single_Use_pH_PV	14616_FERM0101.Temperatura_PV
DateTime
2024-09-10 21:45:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.295185
2024-09-10 22:00:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.191056
2024-09-10 22:15:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.328248
2024-09-10 22:30:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.131252
2024-09-10 22:45:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.176001
2024-09-10 23:00:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.268666
2024-09-10 23:15:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.216003
2024-09-10 23:30:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.169230
2024-09-10 23:45:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.171162
2024-09-11 00:00:00.000	0.0	0.0	480.0	0.0	0.0	0.0	-17.2	1.306835	-0.232956	0.0	22.320001	0.0	0.0	799.991992	799.919971	15.217546

Most frequently occurring

	14616_FERM0101.Agitation_PV	14616_FERM0101.Air_Sparge_PV	14616_FERM0101.Biocontainer_Pressure_PV	14616_FERM0101.DO_1_PV	14616_FERM0101.DO_2_PV	14616_FERM0101.Gas_Overlay_PV	14616_FERM0101.Load_Cell_Net_PV	14616_FERM0101.pH_1_PV	14616_FERM0101.pH_2_PV	14616_FERM0101.PUMP_1_PV	14616_FERM0101.PUMP_1_TOTAL	14616_FERM0101.PUMP_2_PV	14616_FERM0101.PUMP_2_TOTAL	14616_FERM0101.Single_Use_DO_PV	14616_FERM0101.Single_Use_pH_PV	14616_FERM0101.Temperatura_PV	# duplicates
1295	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4359
2	0.0	0.0	-0.784143	0.0	0.0	3.999837	0.8	1.543468	3.2	0.0	0.000000	0.0	4910.504687	799.991992	800.016016	16.647998	61
1089	0.0	0.0	480.000000	0.0	0.0	0.000000	0.0	0.006012	3.2	0.0	44.639993	0.0	1321.104004	32921.481250	799.919971	24.407996	16
1083	0.0	0.0	480.000000	0.0	0.0	0.000000	0.0	0.006012	3.2	0.0	44.639993	0.0	1321.104004	32921.481250	799.919971	24.312000	15
1090	0.0	0.0	480.000000	0.0	0.0	0.000000	0.0	0.006012	3.2	0.0	44.639993	0.0	1321.104004	32921.481250	799.919971	24.431995	15
1080	0.0	0.0	480.000000	0.0	0.0	0.000000	0.0	0.006012	3.2	0.0	44.639993	0.0	1321.104004	32921.481250	799.919971	24.271997	13
1138	0.0	0.0	480.000000	0.0	0.0	0.000000	0.0	0.006012	3.2	0.0	44.639993	0.0	1321.104004	32921.481250	799.919971	25.200000	13
548	0.0	0.0	480.000000	0.0	0.0	0.000000	-18.0	1.674920	3.2	0.0	39.679996	0.0	5933.626953	538.461279	799.695996	15.912000	12
579	0.0	0.0	480.000000	0.0	0.0	0.000000	-18.0	1.674920	3.2	0.0	39.679996	0.0	5933.626953	538.461279	799.695996	16.383997	12
628	0.0	0.0	480.000000	0.0	0.0	0.000000	-18.0	1.674920	3.2	0.0	39.679996	0.0	5933.626953	538.461279	799.695996	17.128003	12

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample

Duplicate rows

Most frequently occurring